You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'KJ'%' AND titel LIKE '%Smith%'' at line 1 SELECT count(*) as cnt FROM ero WHERE titel LIKE '%Khaneshia%' AND titel LIKE '%'KJ'%' AND titel LIKE '%Smith%' You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'KJ'%' AND titel LIKE '%Smith%' ORDER BY titel, alt ASC LIMIT 0, 15' at line 1 SELECT * FROM ero WHERE titel LIKE '%Khaneshia%' AND titel LIKE '%'KJ'%' AND titel LIKE '%Smith%' ORDER BY titel, alt ASC LIMIT 0, 15